Create a PivotChart report from an existing PivotTable report
Do one of the following:
Make a default chart in one step
Click the PivotTable report, and then click Chart Wizard .
Use the Chart Wizard to create a customized chart
Click a cell outside and not adjacent to the PivotTable report.
Click Chart Wizard .
Click a chart type in step 1 of the wizard. You can use any chart type except xy (scatter), bubble, or stock.
In step 2 of the wizard, click the PivotTable report, so that the reference in the Data range box expands to include the entire report.
Follow the instructions in the remaining Chart Wizard steps.
Create a PivotChart report from other data
If you are basing the report on an Excel list or database, click a cell in the list or database.
Usually you can lay out the report on the screen. Use the wizard to lay out the report if you expect retrieval from a large external data source to be slow, or you need to set page fields to retrieve data one page at a time. If you aren't sure, try laying out the report on the screen. You can return to the wizard if necessary.
Lay out the report on the screen
If you don't see the field list, click within the outlines of the drop areas, and if necessary click Show Field List on the PivotTable toolbar to display the field list.
To see what levels of detail are available in fields that have levels, click next to the field.
Only fields that have the or icon can be dragged to this area.
Note If data is very slow to appear as you lay out the report, click the associated PivotTable report for the PivotChart report and then click Always Display Pivot Items on the PivotTable toolbar to turn off initial data display. If retrieval is still very slow or error messages appear, click the associated PivotTable report for the PivotChart report, click PivotTable and PivotChart Report on the Data menu, and then lay out the report in the wizard.
Lay out the report in the wizard
If you've exited from the wizard, click PivotTable and PivotChart Report on the Data menu to return to it.
If you want Excel to retrieve external data one page at a time, so that you can work with large amounts of source data, double-click the page field, click Advanced, click Query external data source as you select each page field item, and then click OK twice.
If you don't want to see the associated PivotTable report for your PivotChart report, you can hide it. Click the worksheet containing the PivotTable report, point to Sheet on the Format menu, and then click Hide.